package com.hydl.power.mapper;

import com.hydl.power.pojo.PowerConsume;
import com.hydl.power.pojo.Project;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface ProjectMapper {
    List<Project> queryProjectId(String cityId);

    List<Project> queryProjectAll();

    Project queryProjectTableName(String projectId);

    List<Project> queryByToken(String token);

    int deleteProjectById(Integer id);

    int addProject(String cityId,String projectName,String longitudeLatitude,String latitudeLatitude,String tableName,String temperatureDataTableName,String powerDataFlag);

    int updateProject(String projectName,Integer id);

    Project queryProjectByProId(String projectId);

    Project queryProjectById(Integer id);

    List<Project> queryProjectByToken(String cityId,String token);

    List<Project> queryProjectLike(@Param("pageNumKey") Integer pageNum, @Param("pageSizeKey") Integer pageSize, String text, String projectId);

    int selectCountByCityId(String cityId);

    Project getProjectByLongitudeAndLatitude(String longitudeLatitude, String latitudeLatitude);

    void createProjectPowerDataTable(String tableName);

    void createTemperatureDataTable(String temperatureDataTableName);
}
